{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Year1","Scratchpad","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":3,"reason":"part_missing"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Year1","index":1,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,1,5,3],[5,4,5,10],[7,13,7,14]]}
[]
[]
[]
[]
[]
[null,"Proposal Title: ",null,null,null,null,null,null,null,null,null,null,"YEAR",null,"2024-25"]
[null,"A. SENIOR PERSONNEL: PI/PD, Co-PI´S, Faculty and Other Senior Associates "]
[null,null,null,"First Name","M","Last Name","Title",null,"Outreach Months","Cost Share Months",null,"Outreach Funds",null,"Cost Share"]
[null,null,null,"FirstName","X","LastName","Title",null,0,0,null,null,0,null,0]
[]
[]
[null,"(",1,") TOTAL SENIOR PERSONNEL (1-6)",null,null,null,null,null,null,null,null,{"$f":"SUM(M9:M11)","v":0},null,{"$f":"SUM(O9:O11)","v":0},"COMMENTS"]
[null,"B. OTHER PERSONNEL (SHOW NUMBERS IN BRACKETS)"]
[null," 1. (",0,") POST DOCTORAL ASSOCIATES",null,null,null,null,0,0,null,null,0,null,0,"Post Doc:"]
[null," 2. (",0,") OTHER PROFESSIONALS (TECHNICIAN, PROGRAMMER, ETC.)",null,null,null,null,0,0,null,null,0,null,0,"Other Professionals:"]
[null," 3. (",0,") GRADUATE STUDENTS",null,null,null,null,null,null,null,null,0,null,0,"Grad Students:"]
[null," 4. (",0,") UNDERGRADUATE STUDENTS",null,null,null,null,null,null,null,null,0,null,0,"Undergrad:"]
[null," 5. (",0,") OTHER",null,null,null,null,null,null,null,null,0,null,0,"Other Persons:"]
[null,null,"TOTAL SALARIES AND WAGES (A+B)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M14:M18) + M12","v":0},null,{"$f":"SUM(O14:O18) + O12","v":0},"Total Salaries:"]
[null,"C. FRINGE BENEFITS @ 28.7%  for full time employees; 10.6% part time employees; 3.4% for graduate assistants",null,null,null,null,null,null,null,null,null,null,0,null,0,"Fringe Benefits:"]
[null,null,"TOTAL SALARIES, WAGES AND FRINGE BENEFITS (A+B+C)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M19:M20)","v":0},null,{"$f":"SUM(O19:O20)","v":0},"Total Salary and Fringe:"]
[]
[null,"D. PERMANENT EQUIPMENT",null,null,null,null,"COSG",null,"Cost Share"]
[null,null,null,"Equipment Item",null,null,null,null,null,null,null,null,null,null,null,"Equipment comments:"]
[]
[]
[null,null,"TOTAL EQUIPMENT",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G24:G26)","v":0},null,{"$f":"SUM(I24:I26)","v":0}]
[null,"E. TRAVEL",null,null,"1. DOMESTIC (INCL. CANADA, MEXICO AND U.S. POSSESSIONS)",null,null,null,null,null,null,null,0,null,0,"Domestic Travel:"]
[null,null,null,null,"2. FOREIGN",null,null,null,null,null,null,null,0,null,0,"Foreign Travel:"]
[null,"F. PARTICIPANT SUPPORT COSTS",null,null,null,null,"COSG",null,"Cost Share"]
[null,null,"1. STIPENDS   ",null,null,null,0,null,0,null,null,null,null,null,null,"Stipends:"]
[null,null,"2. TRAVEL",null,null,null,0,null,0,null,null,null,null,null,null,"Travel:"]
[null,null,"3. SUBSISTENCE",null,null,null,0,null,0,null,null,null,null,null,null,"Subsistence:"]
[null,null,"4. OTHER",null,null,null,0,null,0,null,null,null,null,null,null,"Other:"]
[null,"(",0,") TOTAL NUMBER OF PARTICIPANTS",null,null,null,null,null,null,null,null,{"$f":"SUM(G31:G34)","v":0},null,{"$f":"SUM(I31:I34)","v":0}]
[null,"G. OTHER DIRECT COSTS"]
[null,null,"1. MATERIALS AND SUPPLIES",null,null,null,null,null,null,null,null,null,0,null,0,"Materials:"]
[null,null,"2. PUBLICATION COSTS/DOCUMENTATION/DISSEMINATION",null,null,null,null,null,null,null,null,null,0,null,0,"Publications:"]
[null,null,"3. CONSULTANT SERVICES",null,null,null,null,null,null,null,null,null,0,null,0,"Consultant:"]
[null,null,"4. COMPUTER SERVICES",null,null,null,null,null,null,null,null,null,0,null,0,"Computer:"]
[null,null,"5. OTHER",null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,"TOTAL OTHER DIRECT COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(M37:M41)","v":0},null,{"$f":"SUM(O37:O41)","v":0},"Other Total:"]
[null,"H. TOTAL DIRECT COSTS (A THROUGH G)",null,null,null,null,null,null,null,null,null,null,{"$f":"M21+M27+M28+M29+M35+M42","v":0},null,{"$f":"O21+O27+O28+O29+O35+O42","v":0},"Direct Total:"]
[null,"I. TOTAL FUNDS APPROVED"]

{"sheet":"Scratchpad","index":2,"n_rows":13,"n_cols":32,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Benefits Scratchpad",null,null,null,null,"Uniform Escalation Scratchpad",null,null,null,null,null,null,null,null,null,"Variable Escalation Scratchpad"]
[null,null,null,null,"Name or Job Title","Division # (1, 3, or 4)","Total Salary/Wages","Benefits",null,"Item","% Escalation","Initial Cost","Year 1","Year 2","Year 3","Year 4","Year 5","Total",null,"Item","Initial Cost","% Escalation","Total Year 1","% Escalation","Total Year 2","% Escalation","Total Year 3","% Escalation","Total Year 4","% Escalation","Total Year 5","Total"]
[null,null,null,null,null,null,null,{"$f":"IF(F4=1,G4*0.235,(IF(F4=3,G4*0.245,(IF(F4=4,G4*0.25,\"Divison # Not Valid\")))))","v":"Divison # Not Valid"},null,null,null,null,{"$f":"ROUND(L4*K4,0)+L4","v":0},{"$f":"ROUND(M4*K4,0)+M4","v":0},{"$f":"ROUND(N4*K4,0)+N4","v":0},{"$f":"ROUND(O4*K4,0)+O4","v":0},{"$f":"ROUND(P4*K4,0)+P4","v":0},{"$f":"SUM(M4:Q4)","v":0},null,null,null,null,{"$f":"IF(V4=0,U4,(ROUND(V4*U4,0)+U4))","v":0},null,{"$f":"IF(X4=0,W4,(ROUND(X4*W4,0)+W4))","v":0},null,{"$f":"IF(Z4=0,Y4,((ROUND(Z4*Y4,0)+Y4)))","v":0},null,{"$f":"IF(AB4=0,AA4,((ROUND(AB4*AA4,0)+AA4)))","v":0},null,{"$f":"IF(AD4=0,AC4,((ROUND(AD4*AC4,0)+AC4)))","v":0},{"$f":"AE4+AC4+AA4+Y4+W4","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F5=1,G5*0.235,(IF(F5=3,G5*0.245,(IF(F5=4,G5*0.25,\"Divison # Not Valid\")))))","v":"Divison # Not Valid"},null,null,null,null,{"$f":"ROUND(L5*K5,0)+L5","v":0},{"$f":"ROUND(M5*K5,0)+M5","v":0},{"$f":"ROUND(N5*K5,0)+N5","v":0},{"$f":"ROUND(O5*K5,0)+O5","v":0},{"$f":"ROUND(P5*K5,0)+P5","v":0},{"$f":"SUM(M5:Q5)","v":0},null,null,null,null,0,null,{"$f":"IF(X5=0,W5,(ROUND(X5*W5,0)+W5))","v":0},null,{"$f":"IF(Z5=0,Y5,((ROUND(Z5*Y5,0)+Y5)))","v":0},null,0,null,0,{"$f":"AE5+AC5+AA5+Y5+W5","v":0}]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,null,null,null,"Divison # Not Valid",null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,"Total",null,null,{"$f":"SUM(H4:H12)","v":0},null,null,null,null,{"$f":"ROUND(L13*K13,0)+L13","v":0},{"$f":"ROUND(M13*K13,0)+M13","v":0},{"$f":"ROUND(N13*K13,0)+N13","v":0},{"$f":"ROUND(O13*K13,0)+O13","v":0},{"$f":"ROUND(P13*K13,0)+P13","v":0},0,null,null,null,null,0,null,0,null,0,null,0,null,0,0]